package com.atguigu.eduservice.entity.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.Date;

@Data
public class LandExcel {
//    @ExcelProperty(value = "分类及字段名称",index = 0)
//    private String index;

    @ExcelProperty(value = "实物ID",index = 1)
    private String physicalId;

    @ExcelProperty(value = "总(分)部/各单位本部(*)",index = 2)
    private String provinceCompanyName;

    @ExcelProperty(value = "地市公司/分支机构（*）",index = 3)
    private String cityCompanyName;

    @ExcelProperty(value = "县级电力公司/其他县级单位",index = 4)
    private String countyCompanyName;

    @ExcelProperty(value = "土地编号",index = 5)
    private String landNum;

    @ExcelProperty(value = "宗地名称(*)",index = 6)
    private String landName;

    @ExcelProperty(value = "省",index = 7)
    private String areaProvinceName;

    @ExcelProperty(value = "市（地、州、盟）",index = 8)
    private String areaCityName;

    @ExcelProperty(value = "区/县(*)",index = 9)
    private String areaCountyName;

    @ExcelProperty(value = "具体位置(*)",index = 10)
    private String detailAddress;

    @ExcelProperty(value = "经纬度(*)",index = 11)
    private String longitudelatitude;

    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @ExcelProperty(value = "土地取得时间(*)",index = 12)
    private Date landAcqDate;

    @ExcelProperty(value = "规划用途(*)",index = 13)
    private String planPurposeName;

    @ExcelProperty(value = "土地性质(*)",index = 14)
    private String landCharacterName;

    @ExcelProperty(value = "土地使用权类型",index = 15)
    private String landUseTypeName;

    @ExcelProperty(value = "土地实际用途",index = 16)
    private String actualLandUseName;

    @ExcelProperty(value = "土地等级",index = 17)
    private String landGradesName;

    @ExcelProperty(value = "取得价格（万元）",index = 18)
    private BigDecimal ackPrice;

    @ExcelProperty(value = "土地面积（平方米）(*)",index = 19)
    private BigDecimal usefulArea;

    @ExcelProperty(value = "已使用面积（平方米）(*)",index = 20)
    private BigDecimal usedArea;

//    @ExcelProperty(value = "闲置面积（平方米）(*)",index = 21)
//    private BigDecimal idleArea;

    @ExcelProperty(value = "是否有证(*)",index = 22)
    private String hasCertificateFlagString;

    @ExcelProperty(value = "土地(不动产)证号",index = 23)
    private String landCardNumber;

    @ExcelProperty(value = "不动产单元号",index = 24)
    private String assetsUnit; //不动产单元号

    @ExcelProperty(value = "土地所有权人",index = 25)
    private String landOwner;

    @ExcelProperty(value = "宗地地号",index = 26)
    private String parcelNo;

    @ExcelProperty(value = "宗地图",index = 27)
    private String landMapId;

    @ExcelProperty(value = "权证图片",index = 28)
    private String authorityCardPicId;

    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @ExcelProperty(value = "使用终止日期",index = 29)
    private Date terminationDate;

    @ExcelProperty(value = "无证原因",index = 30)
    private String noLicenseReasonName;

    @ExcelProperty(value = "土地实际持有人",index = 31)
    private String actualLandHolder;

    @ExcelProperty(value = "附着建筑物数量",index = 32)
    private Integer buildingNum;

    @ExcelProperty(value = "资产编码",index = 33)
    private String assetsNum;

    @ExcelProperty(value = "资产原值（元）",index = 34)
    private BigDecimal assetsOrigValue;

    @ExcelProperty(value = "资产净值（元）",index = 35)
    private BigDecimal assetsNetValue;

    @ExcelProperty(value = "资产增加方式",index = 36)
    private String assetsIncreaseWayName;

//    @ExcelProperty(value = "所属土地",index = 37)
//    private String subordinateToLand;

    @ExcelProperty(value = "实物管理部门名称",index = 38)
    private String physicalManagementDepartmentName; //

    @ExcelProperty(value = "使用总(分)部/各单位本部名称",index = 39)
    private String useProvinceCompanyName;

    @ExcelProperty(value = "使用地市公司/分支机构名称",index = 40)
    private String useCityCompanyName;

    @ExcelProperty(value = "使用县级电力公司/其他县级单位名称",index = 41)
    private String useCountyCompanyName;

    @ExcelProperty(value = "使用部门名称",index = 42)
    private String useDepartmentName;

    @ExcelProperty(value = "备注",index = 43)
    private String remark;


}
